﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace edowork.com.Model
{
    #region announcementInfo

    [Serializable]
    public class announcementInfo
    {
        #region Private fields

        protected string _id = String.Empty;
        protected string _title = String.Empty;
        protected string _p_date = String.Empty;
        protected string _e_date = String.Empty;
        protected string _content = String.Empty;
        protected string _userid = String.Empty;
        protected string _p_range = String.Empty;
        protected string _departmentid = String.Empty;
        protected string _sysdate = String.Empty;
        protected string _attach1 = String.Empty;
        protected string _attach2 = String.Empty;
        protected string _attach1filename = String.Empty;
        protected string _attach2filename = String.Empty;

        #endregion

        public announcementInfo() { }

        #region Public Properties

        public string ID
        {
            get { return _id; }
            set { _id = value; }
        }

        public string Title
        {
            get { return _title; }
            set { _title = value; }
        }

        public string P_date
        {
            get { return _p_date; }
            set { _p_date = value; }
        }

        public string E_date
        {
            get { return _e_date; }
            set { _e_date = value; }
        }

        public string Content
        {
            get { return _content; }
            set { _content = value; }
        }

        public string Userid
        {
            get { return _userid; }
            set { _userid = value; }
        }

        public string P_range
        {
            get { return _p_range; }
            set { _p_range = value; }
        }

        public string Departmentid
        {
            get { return _departmentid; }
            set { _departmentid = value; }
        }

        public string Sysdate
        {
            get { return _sysdate; }
            set { _sysdate = value; }
        }

        public string Attach1
        {
            get { return _attach1; }
            set { _attach1 = value; }
        }

        public string Attach2
        {
            get { return _attach2; }
            set { _attach2 = value; }
        }

        public string Attach1filename
        {
            get { return _attach1filename; }
            set { _attach1filename = value; }
        }

        public string Attach2filename
        {
            get { return _attach2filename; }
            set { _attach2filename = value; }
        }

        #endregion

        #region Public SQL Script

        public string SQL_Insert()
        {
            return "insert into announcement(Title,p_date,e_date,content,userid,p_range,departmentid,sysdate,attach1,attach2, attach1filename, attach2filename) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}', '{10}', '{11}')";
        }

        #endregion

    }

    #endregion
}
